Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

Modifying tables to support arrays

The DataServer allows you to extend OpenEdge’s ability to support database arrays to your ODBC data source. To have access to this functionality, you must make certain changes to your data-source table.

To modify tables to support arrays:

Name the columns of a data-source table that you want the DataServer to roll into an array column##1, column##2, etc. The columns must be adjacent and in sequence.
Make sure that these columns are of the same data type. For example, if you want the schema holder to include an array named MONTH with 12 elements, the ODBC data-source table must have 12 adjacent columns of the same data type named month##1, month##2, month##3, and so forth. OpenEdge names the corresponding field in the schema holder month. In your applications, refer to each element of the array as month[1], month[2], month[3], and so forth.
If you have already created your schema holder, update it to reflect your changes to the data-source table.
Note: For Informix arrays, enter the text "_ _" (two underscores) instead of "##" (two number signs).